This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
I suspect that it is not reading the CSV files and getting the values from there that is slow, I suspect it is the validation/lookups.
I agree with Simon, use a profiler or just add some timing code to the agent to see where the slowness is.
I am sure that you can rewrite the lookups/validation to be much faster, and thereby speed up the agent. You just need to find where the bottle neck is.
In your validation/lookups, are you opening the Notes documents or reading the view column values? I find that using ColumnValues() in a situation like that is much faster, about 100 times faster, actually.
Check out my test results here: http://planetlotus.org/aab66c
Feedback response number WEBB959MBN created by ~Dan Kikiterobu on 02/25/2013